<?php 
	
    $conn = oci_connect("hospital", "hospital", "//localhost/XE"); 
	$ss = "UPDATE record SET PRESCRIPTION_ID = '$_POST[pre_id]]', GENERALP_ID = '$_POST[std_id]'
                 WHERE PRESCRIPTION_ID = '$_GET[col]' ";
	$update= oci_parse($conn,$ss);
	oci_execute($update);
 ?>
 
<html>
<head><meta http-equiv="refresh" content="1; URL=main.php"></head>
<BODY bgcolor = "#ffffff">
 <font color="#ffffff" size="20">Redirecting ...</font>
 </body>
 </html>